package com.ftwj.demo.base.constant;

/**
*
* <p>Title: QueryModel</p>  
* <p>Description: 添加查询时的特殊查询条件</p>
* <p>Copyright: Copyright (c) 2020 </p>  
* <p>Company: 兰州飞天网景信息产业有限公司</p>    
* @author WangSLi
* @date 2020年3月17日 下午11:01:03
* @version V1.0
 */
public interface QueryModel {
	
	/**
	 * 	`column` = ? 查询
	 */
	String EQUALS = "= ?";
	/**
	 * 	`column` > ? 查询
	 */
	String GREATER_THAN = "> ?";
	/**
	 * 	`column` >= ? 查询
	 */
	String GREATER_THAN_EQUALS=">= ?";
	/**
	 * 	`column` < ? 查询
	 */
	String LESS_THAN = "< ?";
	/**
	 * 	`column` <= ? 查询
	 */
	String LESS_THAN_EQUALS="<= ?";
	/**
	 * 	`column` <> ? 查询
	 */
	String UNEQUAL_TO = "<> ?";
	/**
	 * 	`column` LIKE CONCAT(?, '%') 查询
	 */
	String LEFT_LIKE = "LIKE CONCAT(?, '%')";
	/**
	 * 	`column` LIKE CONCAT('%', ?) 查询
	 */
	String RIGHT_LIKE = "LIKE CONCAT('%', ?)";
	/**
	 * 	`column` LIKE CONCAT('%', ?, '%') 查询
	 */
	String ALL_LIKE = "LIKE CONCAT('%', ?, '%')";

	/**
	 * NOT LIKE CONCAT('%', ?, '%') 查询
	 */
	String NOT_LIKE_CONCAT="NOT LIKE CONCAT('%', ?, '%')";
	/**
	 *  BETWEEN ? AND ?
	 */
	String BETWEEN_AND="BETWEEN ? AND ? ";
	/**
	 * NOT BETWEEN ? AND ?
	 */
	String NOT_BETWEEN_AND="NOT BETWEEN ? AND ? ";

}
